<%-- 
    Document   : loadcity
    Created on : May 4, 2012, 3:36:24 AM
    Author     : Haridwar
--%>

<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="jobportal.Dbconn"%>
<%try {
        Connection con = Dbconn.getConn();
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("select district from dist where state='"+request.getParameter("state")+"' order by district");
        while(rs.next()){
            out.print("<option value=\"" + rs.getString(1) + "\">" + rs.getString(1) + "</option>");
        }
    } catch (Exception e) {
        out.println(e);
    }
%>